package com.xiaoxu.intranetweb.mybatisplusSzappdb.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.xiaoxu.intranetweb.mybatisplusSzappdb.entity.CCompanys;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.math.BigDecimal;

/**
 * <p>
 * 单位信息表 Mapper 接口
 * </p>
 *
 * @author xiaoxu
 * @since 2022-12-27
 */
@Component
@DS("szappdb")
public interface CCompanysMapper extends BaseMapper<CCompanys> {
    @Select("SELECT * \n" +
            "FROM c_companys \n" +
            "WHERE ID = #{id} \n" +
            "AND CPY_DELETED = 0 \n" +
            "AND DATA_FROM = #{dataFrom}")
    CCompanys getCompanyById(String id, String dataFrom);
}
